|The formula contains relative references, so they are allowed to change. If you do not want a formula to change, you can use absolute references.|5590|2265|1350|2835||0|0|0|0|
|The spreadsheet has changed the relative references in the original formula. Because the property value was one row below the original, the spreadsheet assumed that the tax rate would also be down one row from its original location.|4210|3930|1590|3600||0|0|1|0|
|The absolute reference has not changed. It still refers to the tax rate in cell B2 and so the new formula produces the correct results.|4605|3505|1365|2580||0|0|3|0|
|Now that you understand the difference between relative and absolute references, you can use them to create valid formulas in your worksheets.|4605|3505|1470|2580||0|0|0|0|